package com.fjd.mapper;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface DeliveryDetailMapper {
    @Select("select delivery_id from delivery_detail where order_id =#{orderId}")
    String select(String orderId);

    @Select("select delivery_batch_id from delivery_detail where tracking_no = #{trackingNumber}")
    String getDeliveryBatchIdByTrackingNumber(String trackingNumber);
}
